Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Expr Abbreviations/Functions? - Mailing list pgsql-sql

From Herouth Maoz
Subject Re: [SQL] Expr Abbreviations/Functions?
Date
Msg-id l03130302b3c0b7a3e162@[147.233.159.109]
Whole thread Raw
In response to Re: [SQL] Expr Abbreviations/Functions?  ("tjk@tksoft.com" <tjk@tksoft.com>)
Responses Re: [SQL] Expr Abbreviations/Functions?  ("tjk@tksoft.com" <tjk@tksoft.com>)
List pgsql-sql
Tree view 
At 02:11 +0300 on 25/07/1999, tjk@tksoft.com wrote:


> You could merge the fields and search with :
>
> select * from tablex where lower(f1||f2||f3) ~ 'foo';

Nah. If f1 is 'Narf' and f2 is 'oodp', it will match...

Herouth

--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma

pgsql-sql by date:

Previous
From: Herouth Maoz
Date:
Subject: Re: [SQL] database design SQL prob.
Next
From: Herouth Maoz
Date:
Subject: Re: [SQL] ERROR: DefineQueryRewrite: rule plan string too big.